explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RirO

Settings
# exclusive inclusive rows x rows loops node
1. 27.561 575.632 ↓ 0.0 0 1

Limit (cost=122,673.00..122,677.25 rows=100 width=1,639) (actual time=575.631..575.632 rows=0 loops=1)

  • JIT:
  • Functions: 50
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 8.788 ms, Inlining 0.000 ms, Optimization 3.711 ms, Emission 71.684 ms, Total 84.183 ms
2. 0.002 548.071 ↓ 0.0 0 1

Unique (cost=122,673.00..124,045.11 rows=32,285 width=1,639) (actual time=548.071..548.071 rows=0 loops=1)

3. 0.000 548.069 ↓ 0.0 0 1

Sort (cost=122,673.00..122,753.71 rows=32,285 width=1,639) (actual time=548.068..548.069 rows=0 loops=1)

  • Sort Key: events.block_number, events.transaction_index, events.transaction_hash, events.log_index, events.event_id, events.block_hash, events.address, events.return_values, events.event, events.signature, events.raw, events.processing_error, events.confirmations, events.created_at, events.updated_at, events.id
  • Sort Method: quicksort Memory: 25kB
4. 45.423 571.664 ↓ 0.0 0 1

Gather (cost=47,192.22..97,302.09 rows=32,285 width=1,639) (actual time=548.048..571.664 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 26.501 526.241 ↓ 0.0 0 3 / 3

Parallel Hash Join (cost=46,192.22..93,073.59 rows=13,452 width=1,639) (actual time=526.239..526.241 rows=0 loops=3)

  • Hash Cond: ((events.return_values #>> '{guid}'::text[]) = (records.guid)::text)
6. 36.976 36.976 ↓ 1.2 16,870 3 / 3

Parallel Index Scan using events_status_index on events (cost=0.43..46,843.84 rows=13,804 width=1,639) (actual time=0.106..36.976 rows=16,870 loops=3)

  • Index Cond: (status = 'Waiting'::event_status)
  • Filter: ((event)::text = ANY ('{RecordUpdated,RecordDiscovery,RecordRetrieval}'::text[]))
  • Rows Removed by Filter: 1
7. 217.957 462.764 ↑ 1.3 205,834 3 / 3

Parallel Hash (cost=42,957.65..42,957.65 rows=258,731 width=44) (actual time=462.763..462.764 rows=205,834 loops=3)

  • Buckets: 1048576 Batches: 1 Memory Usage: 56672kB
8. 244.807 244.807 ↑ 1.3 205,834 3 / 3

Parallel Seq Scan on records (cost=0.00..42,957.65 rows=258,731 width=44) (actual time=16.322..244.807 rows=205,834 loops=3)

  • Filter: (status = 'Mined'::record_status)
  • Rows Removed by Filter: 6625
Planning time : 0.432 ms
Execution time : 602.684 ms