explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RAks

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 10,762.734 ↑ 1.0 26 1

Limit (cost=1,000.75..4,213.28 rows=26 width=102) (actual time=10,762.578..10,762.734 rows=26 loops=1)

2. 0.000 10,762.714 ↑ 8,574.1 26 1

Gather Merge (cost=1,000.75..27,545,595.49 rows=222,927 width=102) (actual time=10,762.575..10,762.714 rows=26 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,982.634 18,430.620 ↑ 5,160.3 18 3

Nested Loop (cost=0.72..27,518,864.16 rows=92,886 width=102) (actual time=6,143.475..6,143.540 rows=18 loops=3)

4. 6,260.424 6,260.424 ↑ 3.6 1,531,260 3

Parallel Index Scan using cwrtransact_creatio_b3c456_idx on cwrtransactions_transaction (cost=0.44..17,393,382.84 rows=5,527,357 width=102) (actual time=12.653..2,086.808 rows=1,531,260 loops=3)

  • Filter: (ack_file_id IS NOT NULL)
  • Rows Removed by Filter: 998072
5. 9,187.562 9,187.562 ↓ 0.0 0 4,593,781

Index Scan using cwrfiles_ackfile_pkey on cwrfiles_ackfile (cost=0.29..1.83 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=4,593,781)

  • Index Cond: (id = cwrtransactions_transaction.ack_file_id)
  • Filter: (society_id = 3)
  • Rows Removed by Filter: 1