explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Owqd

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=9,803,025.09..9,803,025.10 rows=1 width=80) (actual rows= loops=)

  • Group Key: qm.id_legal, l.name, l.full_name
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,492,813.73..9,803,025.09 rows=1 width=80) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,492,813.45..9,803,024.74 rows=1 width=2) (actual rows= loops=)

  • Hash Cond: (((qm.id_operation)::character varying)::text = (ce.session)::text)
  • Filter: (ce.id_operation IS NULL)
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..27,747.98 rows=47,915 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on master qm (cost=0.00..0.00 rows=1 width=10) (actual rows= loops=)

  • Filter: ((time_server > '2019-03-11 00:00:00+05'::timestamp with time zone) AND (time_server < '2019-03-12 00:00:00+05'::timestamp with time zone) AND (id_provider = ANY ('{3220,3700,2381}'::integer[])))
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on collector_out qm_1 (cost=5,384.56..27,591.80 rows=47,910 width=10) (actual rows= loops=)

  • Recheck Cond: (id_provider = ANY ('{3220,3700,2381}'::integer[]))
  • Filter: ((time_server > '2019-03-11 00:00:00+05'::timestamp with time zone) AND (time_server < '2019-03-12 00:00:00+05'::timestamp with time zone))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on collector_out_id_provider_key (cost=0.00..5,372.58 rows=170,573 width=0) (actual rows= loops=)

  • Index Cond: (id_provider = ANY ('{3220,3700,2381}'::integer[]))
8. 0.000 0.000 ↓ 0.0

Index Scan using operations_y2019m03_time_server_key on y2019m03 qm_2 (cost=0.43..8.45 rows=1 width=10) (actual rows= loops=)

  • Index Cond: ((time_server > '2019-03-11 00:00:00+05'::timestamp with time zone) AND (time_server < '2019-03-12 00:00:00+05'::timestamp with time zone))
  • Filter: (id_provider = ANY ('{3220,3700,2381}'::integer[]))
9. 0.000 0.000 ↓ 0.0

Index Scan using queue_id_provider_key on queue qm_3 (cost=0.41..147.72 rows=3 width=10) (actual rows= loops=)

  • Index Cond: (id_provider = ANY ('{3220,3700,2381}'::integer[]))
  • Filter: ((time_server > '2019-03-11 00:00:00+05'::timestamp with time zone) AND (time_server < '2019-03-12 00:00:00+05'::timestamp with time zone))
10. 0.000 0.000 ↓ 0.0

Hash (cost=3,115,796.20..3,115,796.20 rows=183,939,620 width=18) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on cyber_external ce (cost=0.00..3,115,796.20 rows=183,939,620 width=18) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using fki_provider_biller_legals_fkey on legals l (cost=0.28..0.34 rows=1 width=80) (actual rows= loops=)